MERGE INTO c1_department A USING
(SELECT
<#assign prefixName = true>
<#if (index_address??)>
${prefixName?string('', ', ')} :index_address_value AS address
<#assign prefixName = false>
</#if>
<#if (index_areaCode??)>
${prefixName?string('', ', ')} :index_areaCode_value AS area_code
<#assign prefixName = false>
</#if>
<#if (index_batchNo??)>
${prefixName?string('', ', ')} :index_batchNo_value AS batch_no
<#assign prefixName = false>
</#if>
<#if (index_beginDate??)>
${prefixName?string('', ', ')} :index_beginDate_value AS begin_date
<#assign prefixName = false>
</#if>
<#if (index_cityCode??)>
${prefixName?string('', ', ')} :index_cityCode_value AS city_code
<#assign prefixName = false>
</#if>
<#if (index_compatibleDepartmentCode1??)>
${prefixName?string('', ', ')} :index_compatibleDepartmentCode1_value AS compatible_department_code_1
<#assign prefixName = false>
</#if>
<#if (index_compatibleDepartmentCode2??)>
${prefixName?string('', ', ')} :index_compatibleDepartmentCode2_value AS compatible_department_code_2
<#assign prefixName = false>
</#if>
<#if (index_compatibleParentCode1??)>
${prefixName?string('', ', ')} :index_compatibleParentCode1_value AS compatible_parent_code_1
<#assign prefixName = false>
</#if>
<#if (index_compatibleParentCode2??)>
${prefixName?string('', ', ')} :index_compatibleParentCode2_value AS compatible_parent_code_2
<#assign prefixName = false>
</#if>
<#if (index_createdByCode??)>
${prefixName?string('', ', ')} :index_createdByCode_value AS created_by_code
<#assign prefixName = false>
</#if>
<#if (index_createdById??)>
${prefixName?string('', ', ')} :index_createdById_value AS created_by_id
<#assign prefixName = false>
</#if>
<#if (index_createdDate??)>
${prefixName?string('', ', ')} :index_createdDate_value AS created_date
<#assign prefixName = false>
</#if>
<#if (index_dataStateCode??)>
${prefixName?string('', ', ')} :index_dataStateCode_value AS data_state_code
<#assign prefixName = false>
</#if>
<#if (index_departmentCode??)>
${prefixName?string('', ', ')} :index_departmentCode_value AS department_code
<#assign prefixName = false>
</#if>
<#if (index_departmentId??)>
${prefixName?string('', ', ')} :index_departmentId_value AS department_id
<#assign prefixName = false>
</#if>
<#if (index_endDate??)>
${prefixName?string('', ', ')} :index_endDate_value AS end_date
<#assign prefixName = false>
</#if>
<#if (index_flagCode??)>
${prefixName?string('', ', ')} :index_flagCode_value AS flag_code
<#assign prefixName = false>
</#if>
<#if (index_flagObjectCode??)>
${prefixName?string('', ', ')} :index_flagObjectCode_value AS flag_object_code
<#assign prefixName = false>
</#if>
<#if (index_jsonData??)>
${prefixName?string('', ', ')} :index_jsonData_value AS json_data
<#assign prefixName = false>
</#if>
<#if (index_lastModifiedByCode??)>
${prefixName?string('', ', ')} :index_lastModifiedByCode_value AS last_modified_by_code
<#assign prefixName = false>
</#if>
<#if (index_lastModifiedById??)>
${prefixName?string('', ', ')} :index_lastModifiedById_value AS last_modified_by_id
<#assign prefixName = false>
</#if>
<#if (index_lastModifiedDate??)>
${prefixName?string('', ', ')} :index_lastModifiedDate_value AS last_modified_date
<#assign prefixName = false>
</#if>
<#if (index_lastSyncTime??)>
${prefixName?string('', ', ')} :index_lastSyncTime_value AS last_sync_time
<#assign prefixName = false>
</#if>
<#if (index_name??)>
${prefixName?string('', ', ')} :index_name_value AS name
<#assign prefixName = false>
</#if>
<#if (index_orderBy??)>
${prefixName?string('', ', ')} :index_orderBy_value AS order_by_
<#assign prefixName = false>
</#if>
<#if (index_orgCode??)>
${prefixName?string('', ', ')} :index_orgCode_value AS org_code
<#assign prefixName = false>
</#if>
<#if (index_orgId??)>
${prefixName?string('', ', ')} :index_orgId_value AS org_id
<#assign prefixName = false>
</#if>
<#if (index_parentCode??)>
${prefixName?string('', ', ')} :index_parentCode_value AS parent_code
<#assign prefixName = false>
</#if>
<#if (index_parentId??)>
${prefixName?string('', ', ')} :index_parentId_value AS parent_id
<#assign prefixName = false>
</#if>
<#if (index_parentTreeCode??)>
${prefixName?string('', ', ')} :index_parentTreeCode_value AS parent_tree_code
<#assign prefixName = false>
</#if>
<#if (index_parentTreeId??)>
${prefixName?string('', ', ')} :index_parentTreeId_value AS parent_tree_id
<#assign prefixName = false>
</#if>
<#if (index_parentTreeName??)>
${prefixName?string('', ', ')} :index_parentTreeName_value AS parent_tree_name
<#assign prefixName = false>
</#if>
<#if (index_personalCode??)>
${prefixName?string('', ', ')} :index_personalCode_value AS personal_code
<#assign prefixName = false>
</#if>
<#if (index_personalId??)>
${prefixName?string('', ', ')} :index_personalId_value AS personal_id
<#assign prefixName = false>
</#if>
<#if (index_provinceCode??)>
${prefixName?string('', ', ')} :index_provinceCode_value AS province_code
<#assign prefixName = false>
</#if>
<#if (index_regionCode??)>
${prefixName?string('', ', ')} :index_regionCode_value AS region_code
<#assign prefixName = false>
</#if>
<#if (index_siteCode??)>
${prefixName?string('', ', ')} :index_siteCode_value AS site_code
<#assign prefixName = false>
</#if>
<#if (index_sourceCode??)>
${prefixName?string('', ', ')} :index_sourceCode_value AS source_code
<#assign prefixName = false>
</#if>
<#if (index_stateCode??)>
${prefixName?string('', ', ')} :index_stateCode_value AS state_code
<#assign prefixName = false>
</#if>
<#if (index_syncReturnCode??)>
${prefixName?string('', ', ')} :index_syncReturnCode_value AS sync_return_code
<#assign prefixName = false>
</#if>
<#if (index_syncReturnMessage??)>
${prefixName?string('', ', ')} :index_syncReturnMessage_value AS sync_return_message
<#assign prefixName = false>
</#if>
<#if (index_systemInfoCode??)>
${prefixName?string('', ', ')} :index_systemInfoCode_value AS system_info_code
<#assign prefixName = false>
</#if>
<#if (index_thirdPartyCode??)>
${prefixName?string('', ', ')} :index_thirdPartyCode_value AS third_party_code
<#assign prefixName = false>
</#if>
<#if (index_version??)>
${prefixName?string('', ', ')} :index_version_value AS version_
<#assign prefixName = false>
</#if>
 FROM DUAL) B
ON (
<#assign prefixName = true>
<#if (index_address??)>
${prefixName?string('', 'AND ')}A.address = B.address
<#assign prefixName = false>
</#if>
<#if (index_areaCode??)>
${prefixName?string('', 'AND ')}A.area_code = B.area_code
<#assign prefixName = false>
</#if>
<#if (index_batchNo??)>
${prefixName?string('', 'AND ')}A.batch_no = B.batch_no
<#assign prefixName = false>
</#if>
<#if (index_beginDate??)>
${prefixName?string('', 'AND ')}A.begin_date = B.begin_date
<#assign prefixName = false>
</#if>
<#if (index_cityCode??)>
${prefixName?string('', 'AND ')}A.city_code = B.city_code
<#assign prefixName = false>
</#if>
<#if (index_compatibleDepartmentCode1??)>
${prefixName?string('', 'AND ')}A.compatible_department_code_1 = B.compatible_department_code_1
<#assign prefixName = false>
</#if>
<#if (index_compatibleDepartmentCode2??)>
${prefixName?string('', 'AND ')}A.compatible_department_code_2 = B.compatible_department_code_2
<#assign prefixName = false>
</#if>
<#if (index_compatibleParentCode1??)>
${prefixName?string('', 'AND ')}A.compatible_parent_code_1 = B.compatible_parent_code_1
<#assign prefixName = false>
</#if>
<#if (index_compatibleParentCode2??)>
${prefixName?string('', 'AND ')}A.compatible_parent_code_2 = B.compatible_parent_code_2
<#assign prefixName = false>
</#if>
<#if (index_createdByCode??)>
${prefixName?string('', 'AND ')}A.created_by_code = B.created_by_code
<#assign prefixName = false>
</#if>
<#if (index_createdById??)>
${prefixName?string('', 'AND ')}A.created_by_id = B.created_by_id
<#assign prefixName = false>
</#if>
<#if (index_createdDate??)>
${prefixName?string('', 'AND ')}A.created_date = B.created_date
<#assign prefixName = false>
</#if>
<#if (index_dataStateCode??)>
${prefixName?string('', 'AND ')}A.data_state_code = B.data_state_code
<#assign prefixName = false>
</#if>
<#if (index_departmentCode??)>
${prefixName?string('', 'AND ')}A.department_code = B.department_code
<#assign prefixName = false>
</#if>
<#if (index_departmentId??)>
${prefixName?string('', 'AND ')}A.department_id = B.department_id
<#assign prefixName = false>
</#if>
<#if (index_endDate??)>
${prefixName?string('', 'AND ')}A.end_date = B.end_date
<#assign prefixName = false>
</#if>
<#if (index_flagCode??)>
${prefixName?string('', 'AND ')}A.flag_code = B.flag_code
<#assign prefixName = false>
</#if>
<#if (index_flagObjectCode??)>
${prefixName?string('', 'AND ')}A.flag_object_code = B.flag_object_code
<#assign prefixName = false>
</#if>
<#if (index_jsonData??)>
${prefixName?string('', 'AND ')}A.json_data = B.json_data
<#assign prefixName = false>
</#if>
<#if (index_lastModifiedByCode??)>
${prefixName?string('', 'AND ')}A.last_modified_by_code = B.last_modified_by_code
<#assign prefixName = false>
</#if>
<#if (index_lastModifiedById??)>
${prefixName?string('', 'AND ')}A.last_modified_by_id = B.last_modified_by_id
<#assign prefixName = false>
</#if>
<#if (index_lastModifiedDate??)>
${prefixName?string('', 'AND ')}A.last_modified_date = B.last_modified_date
<#assign prefixName = false>
</#if>
<#if (index_lastSyncTime??)>
${prefixName?string('', 'AND ')}A.last_sync_time = B.last_sync_time
<#assign prefixName = false>
</#if>
<#if (index_name??)>
${prefixName?string('', 'AND ')}A.name = B.name
<#assign prefixName = false>
</#if>
<#if (index_orderBy??)>
${prefixName?string('', 'AND ')}A.order_by_ = B.order_by_
<#assign prefixName = false>
</#if>
<#if (index_orgCode??)>
${prefixName?string('', 'AND ')}A.org_code = B.org_code
<#assign prefixName = false>
</#if>
<#if (index_orgId??)>
${prefixName?string('', 'AND ')}A.org_id = B.org_id
<#assign prefixName = false>
</#if>
<#if (index_parentCode??)>
${prefixName?string('', 'AND ')}A.parent_code = B.parent_code
<#assign prefixName = false>
</#if>
<#if (index_parentId??)>
${prefixName?string('', 'AND ')}A.parent_id = B.parent_id
<#assign prefixName = false>
</#if>
<#if (index_parentTreeCode??)>
${prefixName?string('', 'AND ')}A.parent_tree_code = B.parent_tree_code
<#assign prefixName = false>
</#if>
<#if (index_parentTreeId??)>
${prefixName?string('', 'AND ')}A.parent_tree_id = B.parent_tree_id
<#assign prefixName = false>
</#if>
<#if (index_parentTreeName??)>
${prefixName?string('', 'AND ')}A.parent_tree_name = B.parent_tree_name
<#assign prefixName = false>
</#if>
<#if (index_personalCode??)>
${prefixName?string('', 'AND ')}A.personal_code = B.personal_code
<#assign prefixName = false>
</#if>
<#if (index_personalId??)>
${prefixName?string('', 'AND ')}A.personal_id = B.personal_id
<#assign prefixName = false>
</#if>
<#if (index_provinceCode??)>
${prefixName?string('', 'AND ')}A.province_code = B.province_code
<#assign prefixName = false>
</#if>
<#if (index_regionCode??)>
${prefixName?string('', 'AND ')}A.region_code = B.region_code
<#assign prefixName = false>
</#if>
<#if (index_siteCode??)>
${prefixName?string('', 'AND ')}A.site_code = B.site_code
<#assign prefixName = false>
</#if>
<#if (index_sourceCode??)>
${prefixName?string('', 'AND ')}A.source_code = B.source_code
<#assign prefixName = false>
</#if>
<#if (index_stateCode??)>
${prefixName?string('', 'AND ')}A.state_code = B.state_code
<#assign prefixName = false>
</#if>
<#if (index_syncReturnCode??)>
${prefixName?string('', 'AND ')}A.sync_return_code = B.sync_return_code
<#assign prefixName = false>
</#if>
<#if (index_syncReturnMessage??)>
${prefixName?string('', 'AND ')}A.sync_return_message = B.sync_return_message
<#assign prefixName = false>
</#if>
<#if (index_systemInfoCode??)>
${prefixName?string('', 'AND ')}A.system_info_code = B.system_info_code
<#assign prefixName = false>
</#if>
<#if (index_thirdPartyCode??)>
${prefixName?string('', 'AND ')}A.third_party_code = B.third_party_code
<#assign prefixName = false>
</#if>
<#if (index_version??)>
${prefixName?string('', 'AND ')}A.version_ = B.version_
<#assign prefixName = false>
</#if>
)
WHEN MATCHED THEN UPDATE SET
<#assign prefixName = true>
<#if (update_address??)>
${prefixName?string('', ', ')}A.address = :update_address_value
<#assign prefixName = false>
</#if>
<#if (update_areaCode??)>
${prefixName?string('', ', ')}A.area_code = :update_areaCode_value
<#assign prefixName = false>
</#if>
<#if (update_batchNo??)>
${prefixName?string('', ', ')}A.batch_no = :update_batchNo_value
<#assign prefixName = false>
</#if>
<#if (update_beginDate??)>
${prefixName?string('', ', ')}A.begin_date = :update_beginDate_value
<#assign prefixName = false>
</#if>
<#if (update_cityCode??)>
${prefixName?string('', ', ')}A.city_code = :update_cityCode_value
<#assign prefixName = false>
</#if>
<#if (update_compatibleDepartmentCode1??)>
${prefixName?string('', ', ')}A.compatible_department_code_1 = :update_compatibleDepartmentCode1_value
<#assign prefixName = false>
</#if>
<#if (update_compatibleDepartmentCode2??)>
${prefixName?string('', ', ')}A.compatible_department_code_2 = :update_compatibleDepartmentCode2_value
<#assign prefixName = false>
</#if>
<#if (update_compatibleParentCode1??)>
${prefixName?string('', ', ')}A.compatible_parent_code_1 = :update_compatibleParentCode1_value
<#assign prefixName = false>
</#if>
<#if (update_compatibleParentCode2??)>
${prefixName?string('', ', ')}A.compatible_parent_code_2 = :update_compatibleParentCode2_value
<#assign prefixName = false>
</#if>
<#if (update_createdByCode??)>
${prefixName?string('', ', ')}A.created_by_code = :update_createdByCode_value
<#assign prefixName = false>
</#if>
<#if (update_createdById??)>
${prefixName?string('', ', ')}A.created_by_id = :update_createdById_value
<#assign prefixName = false>
</#if>
<#if (update_createdDate??)>
${prefixName?string('', ', ')}A.created_date = :update_createdDate_value
<#assign prefixName = false>
</#if>
<#if (update_dataStateCode??)>
${prefixName?string('', ', ')}A.data_state_code = :update_dataStateCode_value
<#assign prefixName = false>
</#if>
<#if (update_departmentCode??)>
${prefixName?string('', ', ')}A.department_code = :update_departmentCode_value
<#assign prefixName = false>
</#if>
<#if (update_departmentId??)>
${prefixName?string('', ', ')}A.department_id = :update_departmentId_value
<#assign prefixName = false>
</#if>
<#if (update_endDate??)>
${prefixName?string('', ', ')}A.end_date = :update_endDate_value
<#assign prefixName = false>
</#if>
<#if (update_flagCode??)>
${prefixName?string('', ', ')}A.flag_code = :update_flagCode_value
<#assign prefixName = false>
</#if>
<#if (update_flagObjectCode??)>
${prefixName?string('', ', ')}A.flag_object_code = :update_flagObjectCode_value
<#assign prefixName = false>
</#if>
<#if (update_jsonData??)>
${prefixName?string('', ', ')}A.json_data = :update_jsonData_value
<#assign prefixName = false>
</#if>
<#if (update_lastModifiedByCode??)>
${prefixName?string('', ', ')}A.last_modified_by_code = :update_lastModifiedByCode_value
<#assign prefixName = false>
</#if>
<#if (update_lastModifiedById??)>
${prefixName?string('', ', ')}A.last_modified_by_id = :update_lastModifiedById_value
<#assign prefixName = false>
</#if>
<#if (update_lastModifiedDate??)>
${prefixName?string('', ', ')}A.last_modified_date = :update_lastModifiedDate_value
<#assign prefixName = false>
</#if>
<#if (update_lastSyncTime??)>
${prefixName?string('', ', ')}A.last_sync_time = :update_lastSyncTime_value
<#assign prefixName = false>
</#if>
<#if (update_name??)>
${prefixName?string('', ', ')}A.name = :update_name_value
<#assign prefixName = false>
</#if>
<#if (update_orderBy??)>
${prefixName?string('', ', ')}A.order_by_ = :update_orderBy_value
<#assign prefixName = false>
</#if>
<#if (update_orgCode??)>
${prefixName?string('', ', ')}A.org_code = :update_orgCode_value
<#assign prefixName = false>
</#if>
<#if (update_orgId??)>
${prefixName?string('', ', ')}A.org_id = :update_orgId_value
<#assign prefixName = false>
</#if>
<#if (update_parentCode??)>
${prefixName?string('', ', ')}A.parent_code = :update_parentCode_value
<#assign prefixName = false>
</#if>
<#if (update_parentId??)>
${prefixName?string('', ', ')}A.parent_id = :update_parentId_value
<#assign prefixName = false>
</#if>
<#if (update_parentTreeCode??)>
${prefixName?string('', ', ')}A.parent_tree_code = :update_parentTreeCode_value
<#assign prefixName = false>
</#if>
<#if (update_parentTreeId??)>
${prefixName?string('', ', ')}A.parent_tree_id = :update_parentTreeId_value
<#assign prefixName = false>
</#if>
<#if (update_parentTreeName??)>
${prefixName?string('', ', ')}A.parent_tree_name = :update_parentTreeName_value
<#assign prefixName = false>
</#if>
<#if (update_personalCode??)>
${prefixName?string('', ', ')}A.personal_code = :update_personalCode_value
<#assign prefixName = false>
</#if>
<#if (update_personalId??)>
${prefixName?string('', ', ')}A.personal_id = :update_personalId_value
<#assign prefixName = false>
</#if>
<#if (update_provinceCode??)>
${prefixName?string('', ', ')}A.province_code = :update_provinceCode_value
<#assign prefixName = false>
</#if>
<#if (update_regionCode??)>
${prefixName?string('', ', ')}A.region_code = :update_regionCode_value
<#assign prefixName = false>
</#if>
<#if (update_siteCode??)>
${prefixName?string('', ', ')}A.site_code = :update_siteCode_value
<#assign prefixName = false>
</#if>
<#if (update_sourceCode??)>
${prefixName?string('', ', ')}A.source_code = :update_sourceCode_value
<#assign prefixName = false>
</#if>
<#if (update_stateCode??)>
${prefixName?string('', ', ')}A.state_code = :update_stateCode_value
<#assign prefixName = false>
</#if>
<#if (update_syncReturnCode??)>
${prefixName?string('', ', ')}A.sync_return_code = :update_syncReturnCode_value
<#assign prefixName = false>
</#if>
<#if (update_syncReturnMessage??)>
${prefixName?string('', ', ')}A.sync_return_message = :update_syncReturnMessage_value
<#assign prefixName = false>
</#if>
<#if (update_systemInfoCode??)>
${prefixName?string('', ', ')}A.system_info_code = :update_systemInfoCode_value
<#assign prefixName = false>
</#if>
<#if (update_thirdPartyCode??)>
${prefixName?string('', ', ')}A.third_party_code = :update_thirdPartyCode_value
<#assign prefixName = false>
</#if>
<#if (update_version??)>
${prefixName?string('', ', ')}A.version_ = :update_version_value
<#assign prefixName = false>
</#if>
WHEN NOT MATCHED THEN INSERT
(<#assign prefixName = true>
<#if (insert_address??) && (insert_address_value??)>
${prefixName?string('  ', ', ')}A.address
<#assign prefixName = false>
</#if>
<#if (insert_areaCode??) && (insert_areaCode_value??)>
${prefixName?string('  ', ', ')}A.area_code
<#assign prefixName = false>
</#if>
<#if (insert_batchNo??) && (insert_batchNo_value??)>
${prefixName?string('  ', ', ')}A.batch_no
<#assign prefixName = false>
</#if>
<#if (insert_beginDate??) && (insert_beginDate_value??)>
${prefixName?string('  ', ', ')}A.begin_date
<#assign prefixName = false>
</#if>
<#if (insert_cityCode??) && (insert_cityCode_value??)>
${prefixName?string('  ', ', ')}A.city_code
<#assign prefixName = false>
</#if>
<#if (insert_compatibleDepartmentCode1??) && (insert_compatibleDepartmentCode1_value??)>
${prefixName?string('  ', ', ')}A.compatible_department_code_1
<#assign prefixName = false>
</#if>
<#if (insert_compatibleDepartmentCode2??) && (insert_compatibleDepartmentCode2_value??)>
${prefixName?string('  ', ', ')}A.compatible_department_code_2
<#assign prefixName = false>
</#if>
<#if (insert_compatibleParentCode1??) && (insert_compatibleParentCode1_value??)>
${prefixName?string('  ', ', ')}A.compatible_parent_code_1
<#assign prefixName = false>
</#if>
<#if (insert_compatibleParentCode2??) && (insert_compatibleParentCode2_value??)>
${prefixName?string('  ', ', ')}A.compatible_parent_code_2
<#assign prefixName = false>
</#if>
<#if (insert_createdByCode??) && (insert_createdByCode_value??)>
${prefixName?string('  ', ', ')}A.created_by_code
<#assign prefixName = false>
</#if>
<#if (insert_createdById??) && (insert_createdById_value??)>
${prefixName?string('  ', ', ')}A.created_by_id
<#assign prefixName = false>
</#if>
<#if (insert_createdDate??) && (insert_createdDate_value??)>
${prefixName?string('  ', ', ')}A.created_date
<#assign prefixName = false>
</#if>
<#if (insert_dataStateCode??) && (insert_dataStateCode_value??)>
${prefixName?string('  ', ', ')}A.data_state_code
<#assign prefixName = false>
</#if>
<#if (insert_departmentCode??) && (insert_departmentCode_value??)>
${prefixName?string('  ', ', ')}A.department_code
<#assign prefixName = false>
</#if>
<#if (insert_departmentId??) && (insert_departmentId_value??)>
${prefixName?string('  ', ', ')}A.department_id
<#assign prefixName = false>
</#if>
<#if (insert_endDate??) && (insert_endDate_value??)>
${prefixName?string('  ', ', ')}A.end_date
<#assign prefixName = false>
</#if>
<#if (insert_flagCode??) && (insert_flagCode_value??)>
${prefixName?string('  ', ', ')}A.flag_code
<#assign prefixName = false>
</#if>
<#if (insert_flagObjectCode??) && (insert_flagObjectCode_value??)>
${prefixName?string('  ', ', ')}A.flag_object_code
<#assign prefixName = false>
</#if>
<#if (insert_jsonData??) && (insert_jsonData_value??)>
${prefixName?string('  ', ', ')}A.json_data
<#assign prefixName = false>
</#if>
<#if (insert_lastModifiedByCode??) && (insert_lastModifiedByCode_value??)>
${prefixName?string('  ', ', ')}A.last_modified_by_code
<#assign prefixName = false>
</#if>
<#if (insert_lastModifiedById??) && (insert_lastModifiedById_value??)>
${prefixName?string('  ', ', ')}A.last_modified_by_id
<#assign prefixName = false>
</#if>
<#if (insert_lastModifiedDate??) && (insert_lastModifiedDate_value??)>
${prefixName?string('  ', ', ')}A.last_modified_date
<#assign prefixName = false>
</#if>
<#if (insert_lastSyncTime??) && (insert_lastSyncTime_value??)>
${prefixName?string('  ', ', ')}A.last_sync_time
<#assign prefixName = false>
</#if>
<#if (insert_name??) && (insert_name_value??)>
${prefixName?string('  ', ', ')}A.name
<#assign prefixName = false>
</#if>
<#if (insert_orderBy??) && (insert_orderBy_value??)>
${prefixName?string('  ', ', ')}A.order_by_
<#assign prefixName = false>
</#if>
<#if (insert_orgCode??) && (insert_orgCode_value??)>
${prefixName?string('  ', ', ')}A.org_code
<#assign prefixName = false>
</#if>
<#if (insert_orgId??) && (insert_orgId_value??)>
${prefixName?string('  ', ', ')}A.org_id
<#assign prefixName = false>
</#if>
<#if (insert_parentCode??) && (insert_parentCode_value??)>
${prefixName?string('  ', ', ')}A.parent_code
<#assign prefixName = false>
</#if>
<#if (insert_parentId??) && (insert_parentId_value??)>
${prefixName?string('  ', ', ')}A.parent_id
<#assign prefixName = false>
</#if>
<#if (insert_parentTreeCode??) && (insert_parentTreeCode_value??)>
${prefixName?string('  ', ', ')}A.parent_tree_code
<#assign prefixName = false>
</#if>
<#if (insert_parentTreeId??) && (insert_parentTreeId_value??)>
${prefixName?string('  ', ', ')}A.parent_tree_id
<#assign prefixName = false>
</#if>
<#if (insert_parentTreeName??) && (insert_parentTreeName_value??)>
${prefixName?string('  ', ', ')}A.parent_tree_name
<#assign prefixName = false>
</#if>
<#if (insert_personalCode??) && (insert_personalCode_value??)>
${prefixName?string('  ', ', ')}A.personal_code
<#assign prefixName = false>
</#if>
<#if (insert_personalId??) && (insert_personalId_value??)>
${prefixName?string('  ', ', ')}A.personal_id
<#assign prefixName = false>
</#if>
<#if (insert_provinceCode??) && (insert_provinceCode_value??)>
${prefixName?string('  ', ', ')}A.province_code
<#assign prefixName = false>
</#if>
<#if (insert_regionCode??) && (insert_regionCode_value??)>
${prefixName?string('  ', ', ')}A.region_code
<#assign prefixName = false>
</#if>
<#if (insert_siteCode??) && (insert_siteCode_value??)>
${prefixName?string('  ', ', ')}A.site_code
<#assign prefixName = false>
</#if>
<#if (insert_sourceCode??) && (insert_sourceCode_value??)>
${prefixName?string('  ', ', ')}A.source_code
<#assign prefixName = false>
</#if>
<#if (insert_stateCode??) && (insert_stateCode_value??)>
${prefixName?string('  ', ', ')}A.state_code
<#assign prefixName = false>
</#if>
<#if (insert_syncReturnCode??) && (insert_syncReturnCode_value??)>
${prefixName?string('  ', ', ')}A.sync_return_code
<#assign prefixName = false>
</#if>
<#if (insert_syncReturnMessage??) && (insert_syncReturnMessage_value??)>
${prefixName?string('  ', ', ')}A.sync_return_message
<#assign prefixName = false>
</#if>
<#if (insert_systemInfoCode??) && (insert_systemInfoCode_value??)>
${prefixName?string('  ', ', ')}A.system_info_code
<#assign prefixName = false>
</#if>
<#if (insert_thirdPartyCode??) && (insert_thirdPartyCode_value??)>
${prefixName?string('  ', ', ')}A.third_party_code
<#assign prefixName = false>
</#if>
<#if (insert_version??) && (insert_version_value??)>
${prefixName?string('  ', ', ')}A.version_
<#assign prefixName = false>
</#if>
)
VALUES
(<#assign prefixName = true>
<#if (insert_address??) && (insert_address_value??)>
${prefixName?string('  ', ', ')}:insert_address_value
<#assign prefixName = false>
</#if>
<#if (insert_areaCode??) && (insert_areaCode_value??)>
${prefixName?string('  ', ', ')}:insert_areaCode_value
<#assign prefixName = false>
</#if>
<#if (insert_batchNo??) && (insert_batchNo_value??)>
${prefixName?string('  ', ', ')}:insert_batchNo_value
<#assign prefixName = false>
</#if>
<#if (insert_beginDate??) && (insert_beginDate_value??)>
${prefixName?string('  ', ', ')}:insert_beginDate_value
<#assign prefixName = false>
</#if>
<#if (insert_cityCode??) && (insert_cityCode_value??)>
${prefixName?string('  ', ', ')}:insert_cityCode_value
<#assign prefixName = false>
</#if>
<#if (insert_compatibleDepartmentCode1??) && (insert_compatibleDepartmentCode1_value??)>
${prefixName?string('  ', ', ')}:insert_compatibleDepartmentCode1_value
<#assign prefixName = false>
</#if>
<#if (insert_compatibleDepartmentCode2??) && (insert_compatibleDepartmentCode2_value??)>
${prefixName?string('  ', ', ')}:insert_compatibleDepartmentCode2_value
<#assign prefixName = false>
</#if>
<#if (insert_compatibleParentCode1??) && (insert_compatibleParentCode1_value??)>
${prefixName?string('  ', ', ')}:insert_compatibleParentCode1_value
<#assign prefixName = false>
</#if>
<#if (insert_compatibleParentCode2??) && (insert_compatibleParentCode2_value??)>
${prefixName?string('  ', ', ')}:insert_compatibleParentCode2_value
<#assign prefixName = false>
</#if>
<#if (insert_createdByCode??) && (insert_createdByCode_value??)>
${prefixName?string('  ', ', ')}:insert_createdByCode_value
<#assign prefixName = false>
</#if>
<#if (insert_createdById??) && (insert_createdById_value??)>
${prefixName?string('  ', ', ')}:insert_createdById_value
<#assign prefixName = false>
</#if>
<#if (insert_createdDate??) && (insert_createdDate_value??)>
${prefixName?string('  ', ', ')}:insert_createdDate_value
<#assign prefixName = false>
</#if>
<#if (insert_dataStateCode??) && (insert_dataStateCode_value??)>
${prefixName?string('  ', ', ')}:insert_dataStateCode_value
<#assign prefixName = false>
</#if>
<#if (insert_departmentCode??) && (insert_departmentCode_value??)>
${prefixName?string('  ', ', ')}:insert_departmentCode_value
<#assign prefixName = false>
</#if>
<#if (insert_departmentId??) && (insert_departmentId_value??)>
${prefixName?string('  ', ', ')}:insert_departmentId_value
<#assign prefixName = false>
</#if>
<#if (insert_endDate??) && (insert_endDate_value??)>
${prefixName?string('  ', ', ')}:insert_endDate_value
<#assign prefixName = false>
</#if>
<#if (insert_flagCode??) && (insert_flagCode_value??)>
${prefixName?string('  ', ', ')}:insert_flagCode_value
<#assign prefixName = false>
</#if>
<#if (insert_flagObjectCode??) && (insert_flagObjectCode_value??)>
${prefixName?string('  ', ', ')}:insert_flagObjectCode_value
<#assign prefixName = false>
</#if>
<#if (insert_jsonData??) && (insert_jsonData_value??)>
${prefixName?string('  ', ', ')}:insert_jsonData_value
<#assign prefixName = false>
</#if>
<#if (insert_lastModifiedByCode??) && (insert_lastModifiedByCode_value??)>
${prefixName?string('  ', ', ')}:insert_lastModifiedByCode_value
<#assign prefixName = false>
</#if>
<#if (insert_lastModifiedById??) && (insert_lastModifiedById_value??)>
${prefixName?string('  ', ', ')}:insert_lastModifiedById_value
<#assign prefixName = false>
</#if>
<#if (insert_lastModifiedDate??) && (insert_lastModifiedDate_value??)>
${prefixName?string('  ', ', ')}:insert_lastModifiedDate_value
<#assign prefixName = false>
</#if>
<#if (insert_lastSyncTime??) && (insert_lastSyncTime_value??)>
${prefixName?string('  ', ', ')}:insert_lastSyncTime_value
<#assign prefixName = false>
</#if>
<#if (insert_name??) && (insert_name_value??)>
${prefixName?string('  ', ', ')}:insert_name_value
<#assign prefixName = false>
</#if>
<#if (insert_orderBy??) && (insert_orderBy_value??)>
${prefixName?string('  ', ', ')}:insert_orderBy_value
<#assign prefixName = false>
</#if>
<#if (insert_orgCode??) && (insert_orgCode_value??)>
${prefixName?string('  ', ', ')}:insert_orgCode_value
<#assign prefixName = false>
</#if>
<#if (insert_orgId??) && (insert_orgId_value??)>
${prefixName?string('  ', ', ')}:insert_orgId_value
<#assign prefixName = false>
</#if>
<#if (insert_parentCode??) && (insert_parentCode_value??)>
${prefixName?string('  ', ', ')}:insert_parentCode_value
<#assign prefixName = false>
</#if>
<#if (insert_parentId??) && (insert_parentId_value??)>
${prefixName?string('  ', ', ')}:insert_parentId_value
<#assign prefixName = false>
</#if>
<#if (insert_parentTreeCode??) && (insert_parentTreeCode_value??)>
${prefixName?string('  ', ', ')}:insert_parentTreeCode_value
<#assign prefixName = false>
</#if>
<#if (insert_parentTreeId??) && (insert_parentTreeId_value??)>
${prefixName?string('  ', ', ')}:insert_parentTreeId_value
<#assign prefixName = false>
</#if>
<#if (insert_parentTreeName??) && (insert_parentTreeName_value??)>
${prefixName?string('  ', ', ')}:insert_parentTreeName_value
<#assign prefixName = false>
</#if>
<#if (insert_personalCode??) && (insert_personalCode_value??)>
${prefixName?string('  ', ', ')}:insert_personalCode_value
<#assign prefixName = false>
</#if>
<#if (insert_personalId??) && (insert_personalId_value??)>
${prefixName?string('  ', ', ')}:insert_personalId_value
<#assign prefixName = false>
</#if>
<#if (insert_provinceCode??) && (insert_provinceCode_value??)>
${prefixName?string('  ', ', ')}:insert_provinceCode_value
<#assign prefixName = false>
</#if>
<#if (insert_regionCode??) && (insert_regionCode_value??)>
${prefixName?string('  ', ', ')}:insert_regionCode_value
<#assign prefixName = false>
</#if>
<#if (insert_siteCode??) && (insert_siteCode_value??)>
${prefixName?string('  ', ', ')}:insert_siteCode_value
<#assign prefixName = false>
</#if>
<#if (insert_sourceCode??) && (insert_sourceCode_value??)>
${prefixName?string('  ', ', ')}:insert_sourceCode_value
<#assign prefixName = false>
</#if>
<#if (insert_stateCode??) && (insert_stateCode_value??)>
${prefixName?string('  ', ', ')}:insert_stateCode_value
<#assign prefixName = false>
</#if>
<#if (insert_syncReturnCode??) && (insert_syncReturnCode_value??)>
${prefixName?string('  ', ', ')}:insert_syncReturnCode_value
<#assign prefixName = false>
</#if>
<#if (insert_syncReturnMessage??) && (insert_syncReturnMessage_value??)>
${prefixName?string('  ', ', ')}:insert_syncReturnMessage_value
<#assign prefixName = false>
</#if>
<#if (insert_systemInfoCode??) && (insert_systemInfoCode_value??)>
${prefixName?string('  ', ', ')}:insert_systemInfoCode_value
<#assign prefixName = false>
</#if>
<#if (insert_thirdPartyCode??) && (insert_thirdPartyCode_value??)>
${prefixName?string('  ', ', ')}:insert_thirdPartyCode_value
<#assign prefixName = false>
</#if>
<#if (insert_version??) && (insert_version_value??)>
${prefixName?string('  ', ', ')}:insert_version_value
<#assign prefixName = false>
</#if>
)

